SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154798 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154798 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278598,871199,627329,44882,900507,350381,397580,75029,853070,687785,672115,894827,171280,545058,226986,567114,478743,801770,775035,958178,285249,649441,642235,261204,455913,62028,358950,548298,279232,1008512,353708,52552,13045,888413,671012,221568,474820,164240,204942,480362,985760,410252,522299,677056,726295,604488,700742,1002652,232151,976860,838487,461220,756890,515918,847133,1045079,958054,32396,412105,789620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001028s ]