SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340580 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340580 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599789,289909,304873,226505,751861,354804,104713,289206,844225,428823,660735,266367,104235,289450,313150,664514,529595,508146,104347,86430,892696,527227,616135,83271,69000,760601,908120,931024,366830,238486,78154,224834,830114,803951,174123,926613,696367,749925,862304,411791,932753,284730,870819,713417,636119,134865,888395,418700,640542,803289,899218,206080,655331,41700,58114,286266,365261,14606,462861,823832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]