SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981851 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981851 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876265,364655,818060,776777,982498,511244,300775,103125,818694,294257,926722,764269,925367,215433,785372,814181,717210,95277,804249,426483,564585,669599,579010,584627,633999,437033,323593,558990,538905,944969,1040764,896423,285525,809761,61837,729343,409022,523293,1023329,528097,603421,855645,605176,218739,803228,178760,130160,316826,503290,95626,975977,152816,946053,959739,175943,10315,828947,778568,1018504,544273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002162s ]