SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597713 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597713 [ RunTime:0.005579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172359,244114,578116,627662,546802,790877,829310,606041,729659,62062,948917,747515,531524,120986,514585,467606,775573,984362,108732,1012836,332644,308591,934704,203534,673820,201293,964251,161181,799633,130412,47557,692517,454395,182975,100474,396379,144735,677374,136045,584019,6311,809368,883093,955005,826199,863527,940698,908170,812383,341541,561124,160680,88501,162927,641561,754911,35399,990696,80960,343643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]