SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200505 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200505 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222296,955746,430971,598900,781164,732064,649540,673265,842058,161989,676864,278361,266694,871270,848497,107487,8478,825783,951090,4173,741070,478026,262943,475865,278702,936008,900544,55300,257340,586847,518642,772655,679305,937336,601128,499343,892002,468727,494804,536406,850917,173244,485904,902116,210339,717971,281663,455918,957374,832019,792154,111089,761024,606280,504657,158826,507421,337962,527767,1032321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]