SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423054 LIMIT 1 [ RunTime:0.000934s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423054 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796739,19111,929087,682379,17262,55402,110763,836454,490619,838805,112776,353932,18586,927627,609074,957693,936794,630358,152728,650187,994349,742757,958348,942952,348683,184291,534584,151726,88515,705596,776269,924840,480068,174855,560738,368281,573247,453655,744385,1048564,481854,459299,373791,707505,678313,348288,104452,597761,501527,291772,1045162,174455,515784,53910,214444,588015,840035,358115,816411,737236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002642s ]