SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323628 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323628 [ RunTime:0.005585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257985,939510,839436,30674,1003774,714371,112407,318376,506754,127883,312937,10879,624996,685902,462386,467086,533477,74552,454878,6228,911819,108398,939389,756994,255025,174424,1038578,559435,58245,146363,405926,888146,323974,793257,800585,464682,900597,78690,860011,984629,1001656,402212,35442,13489,650172,663957,856546,976562,915087,526945,719394,698510,943843,174170,130257,572581,625609,140273,51789,614447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]