SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 701026 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 701026 [ RunTime:0.004155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215226,708518,180437,131211,8429,282361,1020796,710386,839209,286735,409693,1045914,154580,13885,242342,160059,786709,727717,742251,882721,406531,418855,417514,142652,577634,496175,771037,612822,963232,285739,128652,231061,210581,921834,80501,4129,619420,9946,625544,82879,177199,631893,188685,829305,550921,164769,967253,1024523,1012010,71086,840940,148144,319642,969176,55246,950921,94609,610483,691021,836691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 701026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 701026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]