SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403002 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403002 [ RunTime:0.002360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232099,6935,237739,532472,357073,151270,1005671,973978,454586,26074,288950,162660,46841,1028873,1040688,996512,644658,699867,900354,840046,544047,271446,239808,699852,28273,695708,405612,815259,7697,879536,18009,289383,622051,141537,496761,695402,291012,554805,570363,441827,743241,746845,207341,1032957,254931,135099,437866,78471,199788,970350,305571,167896,828035,279233,766210,18889,887585,557765,64471,5771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004995s ]