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` = 1017919 LIMIT 1 [ RunTime:0.000674s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017919 [ RunTime:0.005441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440055,762780,595069,188040,885803,56557,610178,789908,967204,713968,845116,778525,546799,3335,48916,493351,492909,596984,591399,971778,696954,819471,540524,763597,295351,470474,561032,944794,865705,200481,337805,176847,884217,975635,170891,704780,448122,484671,247952,145108,451843,995753,330257,1012346,813908,634533,584157,176554,1002566,416822,959162,914845,75262,681110,567942,114335,671903,82339,935749,1047314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000759s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]