SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038014 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038014 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102266,478699,118667,918383,662488,504991,387023,822473,612112,2859,179290,515140,299043,613093,364484,870583,538522,632340,218623,242029,628195,953568,368870,297063,469993,1027128,975101,267066,680914,221282,813081,265216,505742,547410,127704,810953,233509,161396,377084,26566,341784,897335,72406,631170,578811,325521,675602,1018728,851727,195350,828500,307951,99069,298317,972204,107702,746668,207235,287588,20995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]