SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810310 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810310 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387868,487371,428559,107723,782354,609737,889367,712203,292947,876400,502001,647181,899625,723990,446848,8344,274442,706240,187053,240808,186324,477018,75788,4357,651785,10921,578805,364322,503795,402720,51941,229087,664188,119245,959089,1035350,814608,184364,938482,156938,105344,404065,75896,160689,576418,499414,184785,694029,10021,993110,231233,200608,437998,186640,983041,968627,489362,36528,659062,548992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]