SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108718 LIMIT 1 [ RunTime:0.003785s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108718 [ RunTime:0.005794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768293,240974,170586,281299,709266,20264,888122,52611,433518,192925,826658,655197,782846,638741,1000143,210941,966761,862152,789349,102249,286456,362914,299787,124177,118472,886542,208250,995498,899015,351713,250506,568232,904303,819292,926396,44257,564613,1046109,988249,535147,105961,1005307,714213,720659,897494,938105,678418,782068,711777,554186,554710,922768,505902,413809,126573,1029637,473495,168226,877091,285454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]