SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447160 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447160 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149390,819616,450016,974766,122069,602490,514738,248043,378629,108752,351273,403759,621860,8310,263695,154802,578379,1221,750438,462170,316539,881642,674272,918385,148057,129033,603681,177696,988116,827365,493978,729904,415643,20428,510029,101293,328125,65537,213156,928040,334123,235133,536934,162347,1027741,180220,1012171,360527,43000,24191,67461,621368,10672,58408,649854,858372,537193,169365,247896,728350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]