SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402143 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402143 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454796,58245,912566,421412,496398,989862,953705,641099,136165,345696,705091,123670,468488,266634,405032,451949,358912,832945,712565,497698,323001,167003,279733,573674,1036323,967740,874582,808016,805439,19292,536136,821296,323893,887287,412622,436353,984483,304346,740617,535285,308634,457474,657783,198762,46573,718008,890699,296588,550866,4399,758905,233218,397116,261649,648926,638655,675313,522394,81019,325544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]