SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102528 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102528 [ RunTime:0.002054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239133,61340,118229,750732,156360,598851,114181,726287,664137,693792,713372,48878,50139,964191,697659,629291,607576,724626,715803,289537,718280,630561,146822,671990,460795,643260,365901,621292,683404,458427,234684,415807,277394,534756,45534,414070,1027980,171049,258025,985928,982203,21123,734519,650355,527378,314218,905239,903336,197367,601151,55701,603428,256962,79153,233883,213831,660138,21694,55101,17638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]