SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401998 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401998 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525524,499467,648737,971525,793811,867809,196426,926210,332502,541698,948016,87146,1006402,138271,760323,1021237,556058,584437,946217,1040530,968368,282393,475561,695066,879603,325869,1017730,69870,872943,86944,850727,885159,541132,970987,613509,124752,519572,827183,757827,1034728,116958,365289,1032602,55881,267349,733503,891420,98205,628599,1041513,567729,619467,455466,665309,1047767,395531,465654,870250,336102,671672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]