SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34230 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34230 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844538,720346,287373,942979,178994,952762,360868,532065,936744,187164,592715,642234,445596,482206,524512,307024,905111,591782,116920,119162,330705,442650,828205,283117,241618,909361,1001387,589895,335035,1016730,1039625,272845,142303,642964,905427,132270,600122,422015,598610,765720,983301,78652,62975,1027881,705190,15731,539037,1009590,623225,811021,349318,494389,828653,1038333,373436,494724,74834,800422,767576,71486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]