SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841912 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841912 [ RunTime:0.003563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322091,543464,478069,586445,25994,494069,621678,810164,34500,69368,8168,605289,50077,143072,273958,867282,1003708,200215,280860,749033,657971,604699,912600,307754,610480,211389,67808,268301,738740,814176,435155,708940,879585,118737,1033154,426523,46899,57189,450192,503310,600914,971863,182747,364154,893899,77904,161685,201794,378279,327617,141776,108813,212437,189177,18952,969327,857049,745844,152238,100898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002327s ]