SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006678 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006678 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940012,1020839,799504,13451,141126,235242,732334,449132,1048690,966345,489281,963507,461873,239921,803485,943,316687,427643,1011224,184886,358015,855694,742317,843303,365714,847368,952648,419601,433722,464608,997768,723061,223428,980671,129139,962039,525271,634748,42171,616881,263346,362029,689616,225187,359934,435022,106473,858121,749389,618371,107827,222602,811308,770093,632171,466735,1012155,177550,346165,293580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]