SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001205 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001205 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596353,785836,949995,179671,1011103,593669,111342,754682,363185,919688,975608,127186,811994,593993,770045,764223,800200,792787,1048493,944920,570517,293191,215402,528709,1009706,450453,587812,1026418,73779,662512,420039,42069,354727,846615,387585,98854,850255,48868,902738,239332,929165,735361,59138,850587,833931,955012,916043,84242,17695,641229,171738,167917,528864,997876,22313,210262,344624,405833,845201,554558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001205 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001205 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]