SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402224 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402224 [ RunTime:0.002073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524398,369701,265730,648574,883979,566244,569990,415548,41424,196217,697431,850402,538925,364958,914246,69005,817496,66506,625310,562920,324792,831313,570502,295552,825214,630209,433601,1037966,206774,139995,418621,452117,205335,888912,509654,73797,714928,687258,204482,1028388,78458,16134,229445,71893,83956,848434,670274,433673,794022,516474,94814,873110,357188,138231,869249,1044676,927866,826992,737097,531922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]