SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484252 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484252 [ RunTime:0.002615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982917,976999,1025859,791076,115249,259921,337034,415316,856814,137245,527470,509796,440539,30132,107898,82616,539998,441376,289438,255816,543247,1037823,410021,138555,211177,915029,139098,747511,1037831,85431,10875,1003760,272351,703642,467644,142417,11709,164447,999898,212887,179856,632823,16325,799901,101647,190373,443120,1015338,771425,351816,108517,590513,581897,61016,727354,441068,468519,309203,451823,989788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484252 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484252 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]