SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438090 LIMIT 1 [ RunTime:0.002844s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438090 [ RunTime:0.003798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459022,492100,567727,17692,235218,270676,249009,1010957,981791,217998,184736,391519,615330,265888,636645,20013,918904,16468,85438,639927,878947,468565,82273,302043,428501,128630,164363,649119,39206,210610,484755,123521,332093,695671,247197,228153,163638,673921,1012119,527206,839483,886697,699397,83943,581632,846833,514644,957525,33073,367706,427955,494693,822582,775360,337122,811120,654360,1017873,668806,188187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]