SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346828 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346828 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219329,234791,66420,763944,757754,231702,132710,993002,856655,67511,944929,894305,490289,201686,767988,121162,660121,1002692,651889,663535,287044,707581,806592,186392,426242,288171,376425,930830,161439,1043084,522448,164150,793522,652172,626285,507014,744285,671056,264250,443541,532347,1000795,809685,261972,149954,696312,243019,557703,594970,891508,259103,484893,181927,156999,657881,881730,111762,462683,974983,63040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]