SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 706834 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 706834 [ RunTime:0.002060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924586,320281,411006,529003,40951,36384,224235,968024,614844,760135,31739,232387,4008,631998,150464,983309,627452,364538,456413,1020229,274128,508839,717579,602213,759128,185133,997328,1022780,41605,481138,350006,855954,509001,33760,304132,205744,539632,779834,1042782,57976,767509,682905,594988,107836,590924,161517,537022,86838,758659,803839,724545,282173,576470,826202,181530,294450,750283,691232,181750,763199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 706834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 706834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]