SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805458 LIMIT 1 [ RunTime:0.001391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805458 [ RunTime:0.009157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755938,870798,984347,792462,992212,393089,140361,258646,32628,786427,171517,587558,382102,578099,988295,132807,663936,299398,804851,530301,822721,972354,246437,543426,692238,1038110,436918,420430,174882,920689,430021,570570,432812,366378,531924,728386,294212,29616,684830,760869,495057,58180,133895,1046948,199598,507213,999016,565348,972916,321499,143382,161646,142098,1027242,851480,909820,923435,991781,729363,882594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]