SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340614 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340614 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107531,626327,234408,246293,150676,746164,753590,192536,459458,308859,354359,735196,757167,128822,165646,113351,719575,862833,121495,979528,289334,170715,167107,64008,840569,199642,149223,1035777,1024110,785737,479802,668841,371627,885630,668601,85268,79243,617038,89402,970477,145423,929750,1044738,540529,296409,1024480,839704,1027729,281067,66644,30577,515598,282294,578697,240482,538884,809487,603990,19036,601100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]