SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291443 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291443 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508668,558797,125491,772728,614876,51698,10074,976591,987665,785665,940030,534757,299513,1002677,827860,229178,678207,442960,676431,85936,360297,89931,651097,215521,209788,1014872,752684,420937,1021712,512213,337482,652378,439566,683866,184886,125836,134701,637185,350114,434309,894566,488842,659512,649649,853952,748147,981353,141605,745782,670504,985035,392774,567229,810084,367925,305989,187514,641964,782058,673034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]