SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550503 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550503 [ RunTime:0.007430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802714,454427,495720,518858,352242,451743,344808,1012349,41734,720508,1025522,523342,166573,474883,562287,12646,351571,303404,560809,702790,665458,217317,201810,977982,89507,653278,883669,666451,460188,718997,857632,259531,545893,1042345,190155,425857,587985,744317,509496,658734,747250,321449,644791,910385,266339,291206,958421,385511,252237,1030228,987600,1024134,145779,297504,399890,253785,22714,98024,704971,316652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]