SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504589 LIMIT 1 [ RunTime:0.001493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504589 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036948,627594,302480,624879,67167,1027873,593122,385164,723582,192223,584686,577545,707607,173625,544178,205161,9311,508269,539089,653008,632101,546776,286141,779774,547493,297487,153611,875625,414065,364352,165614,490021,304185,409612,159106,181499,849213,528761,359770,1039836,806946,99537,968383,161459,336692,414357,349666,978644,812640,1041854,112530,188048,234998,586498,51106,128800,698002,736295,793627,1017899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]