SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420480 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420480 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558647,407161,808759,842563,219164,948331,94257,1044285,86593,933731,65861,6026,102160,114926,274240,181756,60370,51547,516824,567970,520750,24105,306265,832401,327952,997506,910502,65279,875800,846841,102712,741959,168644,659201,996382,436091,724826,541300,586681,929294,990905,1039269,642230,705141,907757,462517,802894,835597,40433,224256,708247,531254,114048,110120,271188,898366,442403,570834,798333,218229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000366s ]