SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433912 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433912 [ RunTime:0.003319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756551,615352,142773,337367,309796,151410,381226,869610,670489,215783,651273,607657,375861,88790,540016,77803,218573,326468,353741,560189,626680,667767,236020,361882,888104,495893,989808,164608,752671,998640,422721,544399,603848,162871,466288,655791,367818,815044,895368,806456,93383,536830,1043486,958580,311133,249300,85872,129245,1037141,66883,214943,121386,404383,884548,332617,50697,801351,995507,812489,691125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000846s ]