SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591854 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591854 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283740,267486,976044,614723,205941,335460,739167,634180,380119,1001370,313840,319126,279197,588623,660888,381324,457345,904306,743835,861934,940192,774539,469559,262153,266740,953710,148953,902383,11843,921884,775586,852102,903766,569490,586044,722612,183865,58133,356863,28756,1016755,92725,559574,444396,1021367,725340,508584,855983,689756,563635,452371,830622,979443,476090,15687,226062,54340,75429,488302,261025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]