SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043341 LIMIT 1 [ RunTime:0.000737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043341 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140904,617909,477551,681841,344291,214367,924882,896363,25281,86823,708360,273587,396623,719783,970413,958479,646364,321634,453979,489346,545873,828685,950510,6163,680839,303325,813386,479288,540253,107673,467965,169578,259637,483490,616360,33833,548712,104086,166267,388977,630105,365796,377102,527162,148073,774763,122372,548530,130191,4512,223274,833654,425479,434251,31001,328764,412311,719208,1021582,468683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]