SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003764s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035006 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035006 [ RunTime:0.003928s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542644,236660,394706,377390,833824,180194,943295,208808,170939,989066,918168,950921,767814,832138,127954,3554,141913,631476,394269,529959,577514,640161,753272,492285,210854,488032,596433,461211,610328,175772,1038777,967168,793215,61692,129949,400092,717041,475715,801842,87380,817807,454784,924787,345846,571446,781578,192740,796536,1035316,1023451,864625,357112,344369,339858,505255,987619,449291,852897,582705,519318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]