SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503961 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503961 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338423,1009428,12854,3885,732986,938228,734874,507296,746117,792312,287708,958183,245179,115299,969556,191116,307816,342410,972275,424917,963125,94984,199892,459196,1041345,216137,939247,1031609,295669,176208,29481,316341,882814,391739,238670,600148,816043,857929,82218,889769,344136,905972,505996,564179,153288,690450,977627,968922,764352,340348,1048002,742733,576794,841683,547458,778183,557831,27619,749016,1009106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]