SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400513 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400513 [ RunTime:0.003726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420168,983828,1011897,649470,868782,151412,21364,524052,610981,611255,1816,868027,678710,902627,390561,997687,266437,104940,719522,88551,941753,266904,576461,623000,337007,465499,344051,628293,1036052,888383,411839,928405,307273,268725,667810,357521,609142,457591,444889,768264,229733,437914,977423,926772,980329,338848,920115,865359,473123,441249,370389,269668,714620,459891,764796,383266,701713,65976,103227,999520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]