SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002720s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475457 LIMIT 1 [ RunTime:0.002397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475457 [ RunTime:0.003748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679413,232712,877834,105382,355381,396710,120000,244097,774973,420631,29252,108149,280213,906884,387410,227012,318286,598483,248919,529578,336530,263982,507982,574893,715267,917849,497284,117049,827653,281330,393221,228658,390535,896674,892074,930957,1040143,575500,353458,70356,802849,569074,1025939,118066,797677,797008,747649,956804,448242,895484,472977,711818,681531,63562,763066,324168,740052,753811,902960,269725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]