SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585181 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585181 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78830,472623,419121,942881,1007064,211548,406565,193226,642259,215290,149188,603176,454662,401182,399901,530507,883624,644308,368249,92015,60787,726747,271064,1032088,333178,889884,437295,916087,30655,37239,549685,496287,683199,36760,318964,66253,859838,462523,872320,718604,302320,774666,1005421,308005,179362,800971,404401,55242,252200,849306,6181,89442,420445,686490,385475,667306,280056,42439,854144,584840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]