SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028305 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028305 [ RunTime:0.002612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198787,287501,29119,575694,475408,853500,383931,1006478,660832,616638,431440,747255,271228,551653,1019261,191387,400782,494582,623140,854652,641714,577065,882049,692522,656829,245643,159325,256101,122893,785263,936858,290379,59165,270526,187079,989864,562735,375044,621933,998748,502374,135625,211133,208267,660313,584735,403703,117417,55124,913662,682003,877102,994637,737156,836511,474627,482084,778598,316331,391840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]