SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014236 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014236 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195607,362825,138111,704833,485117,781808,763648,380034,602757,977250,492445,64040,74890,951388,375971,341025,305103,248249,608532,881500,192679,392838,587191,219959,915535,945947,673375,957793,391001,893365,23410,104082,191815,102159,867402,615306,453723,192356,76586,818159,135202,1021779,27534,486933,451877,556664,514040,841595,633356,176700,1037895,984284,665527,116684,534633,133196,802870,438756,218351,752317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]