SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432144 LIMIT 1 [ RunTime:0.002936s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432144 [ RunTime:0.002610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819176,867959,702968,122393,1048904,882751,90313,776777,822186,465195,278917,229718,566674,392588,283562,1042879,944273,182897,210408,215858,549451,424162,436666,305986,51479,855145,171990,398759,582026,643343,903937,377407,472883,556929,562378,394374,718145,203,362128,779074,623956,689018,386748,952609,102132,579203,92659,331682,553868,399534,819019,19674,789670,63044,780489,2706,434644,35859,290305,206969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001900s ]