SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503691 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503691 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349011,824983,918672,36614,527820,500896,1007530,235777,234565,1030909,702042,799506,128716,94218,106583,640895,188922,808108,975436,700968,314738,69778,1047979,375053,852352,180174,20150,759137,15528,972001,230843,641459,269820,1007507,107667,750484,655790,851508,225110,951567,213095,137284,561841,83940,355497,746582,1048504,916737,300839,902800,626702,712032,649661,446908,363474,1007294,65249,952150,666796,956220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]