SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012706 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012706 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958690,762040,787495,646018,422765,270358,949524,559891,54553,424767,153693,749458,600274,117023,832659,170344,477351,550585,304496,158524,330583,327102,347522,723723,934357,19814,461378,454112,133585,52527,896707,567402,507438,674176,976681,850846,554641,440187,818700,1047150,588875,161317,325946,433546,956366,942601,337934,850710,487955,474880,699952,269534,486593,470631,332510,993176,628493,468415,581777,946428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000892s ]