SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042615 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042615 [ RunTime:0.002360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779809,1018186,692880,981128,142132,225142,485964,834949,970692,63758,839886,67566,812975,89216,544766,337235,427779,680902,804479,836236,462296,424576,680424,259743,206225,5386,93840,790521,575704,331937,286475,12006,926490,531056,399636,114348,287157,105859,254368,824342,714907,1024231,45088,625690,686398,220620,523985,315654,780173,118679,98475,228541,739740,482985,2544,775951,345262,72512,63241,530326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]