SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291024 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291024 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19613,42845,1004531,692491,376210,99915,146918,898550,787886,301712,210592,524802,745600,819444,435714,574587,115789,142792,905614,340303,186252,758412,489424,774439,176816,216979,409339,36141,480651,682618,478607,259540,891193,703370,70030,194666,996702,743279,2805,941891,467711,579915,731247,100329,220024,104315,797142,142627,709546,556679,846537,78689,577971,194428,909180,661283,877925,542724,621100,447365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]