SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029479 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029479 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531826,333894,293203,732247,930299,360687,1001068,912848,556887,555142,616207,203414,93272,705590,391511,55283,310260,427293,597547,1032382,271173,616300,569873,145392,422145,321028,413948,318184,917112,380392,117092,219716,655536,819031,806272,609373,386022,950679,433237,799074,759980,652959,509095,887919,737082,104697,772045,483564,932989,410690,938536,512816,454862,887916,180604,92707,192408,600414,689706,56630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]