SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100604 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100604 [ RunTime:0.005023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692173,921216,389983,292692,1015341,326332,75749,623092,668503,79410,915187,832384,956790,703828,440640,1014211,506362,560615,434053,30590,580902,723671,137840,367769,163540,62089,683695,857297,565568,187205,862801,76035,1009244,628945,597163,77118,363775,922218,307465,821367,413897,341060,987088,190450,634750,295468,869289,349023,578122,684564,905252,198181,55481,467582,107941,351708,856282,352734,691169,237439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]