SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404098 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404098 [ RunTime:0.003656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629038,970830,664692,80272,19736,249869,6169,27921,485892,442089,373475,651712,748838,489345,998477,482462,950514,641701,772857,246787,722361,460588,481067,68816,72360,46070,650380,721369,455029,358291,64080,901923,855461,711054,172396,627081,932016,496094,15490,741872,375733,445152,181422,809748,1021351,370124,754541,115170,17919,253764,481251,348729,637129,363531,524036,509838,226463,367575,917971,100326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001803s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]