SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343751 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343751 [ RunTime:0.002791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030343,654472,819037,366598,387984,980232,978082,459702,94324,239943,525873,141263,895361,308365,50641,522852,852882,4082,768765,106126,182149,752942,352351,1024940,191059,767048,64643,403181,303743,88600,604526,407643,295521,904400,256087,529837,386915,995811,381037,48918,850449,793122,349966,152111,996426,621627,535177,983714,71815,710454,255129,714916,427257,900358,651965,14132,29566,27225,968660,744677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]