SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400868 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400868 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313720,1044037,860870,360169,889708,1040338,109558,446060,726157,702346,573724,512648,49703,592078,748561,426052,312786,116348,493255,144071,201167,296071,637060,793792,606006,1039309,528256,633682,373644,43930,20326,425788,650764,428062,364727,1023927,225153,395830,239356,146967,277836,383038,481423,111498,848298,436713,47046,391590,941802,233598,583375,886701,921912,535848,507377,300809,1009715,808880,726077,259715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]