SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539203 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539203 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692343,551190,255663,293473,16460,743467,371663,1043156,36345,184480,546157,29434,525422,756145,29508,646530,914047,14524,666869,110204,58401,984021,113605,377510,879740,232015,235829,116793,5574,537404,950131,460931,792882,693958,674009,185065,203692,958459,435402,737983,58159,646953,856281,283367,553828,721622,708248,557591,1024282,226660,134265,502296,919107,941957,281353,1022875,148036,881377,926059,47133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]