SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532078 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532078 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764617,215387,651716,127492,489857,690716,758500,549741,548691,777903,71982,268962,773136,853656,477302,923960,724766,852500,493711,885818,976829,560286,495210,552573,52495,88242,451063,930998,648395,843534,99991,656832,204807,556718,1048852,810910,141838,413000,285993,56807,844133,408469,969878,619070,970149,951185,967244,1009701,611977,98768,287782,392342,318779,313726,539000,316044,799754,334977,774907,964001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]