SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502898 LIMIT 1 [ RunTime:0.000855s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502898 [ RunTime:0.002205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160481,514683,71304,433666,1006510,349668,417005,808091,298532,530277,500440,208616,721578,907452,513907,474415,885354,260428,310968,658206,588870,942630,868870,360817,195975,48471,41956,675644,634006,247756,499608,218219,561162,291441,266140,355915,164662,696809,803767,753938,1037391,797902,654881,70033,950080,129636,328775,619998,77468,645200,10210,632382,707259,812578,904266,18904,702267,62041,386952,710851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]