SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003713s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297825 LIMIT 1 [ RunTime:0.003186s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297825 [ RunTime:0.005534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356649,385112,1031614,940043,628461,160920,502142,138798,185917,141290,821688,821359,624900,796651,918477,956606,782211,423706,600431,1038132,458011,577989,900389,367025,813584,425360,66090,614512,43193,696392,995268,205802,534385,470031,96780,951764,351329,98587,700911,561520,499697,540554,764458,838480,583341,114220,1044606,136160,307466,174622,45196,272681,670732,700126,825274,706840,941956,992242,551950,646495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]