SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040778 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040778 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594159,590786,541065,364376,281207,676235,610106,672288,438007,260028,181466,302498,931101,35073,576935,953598,243076,269114,414677,895252,190493,482402,296972,836174,795482,839744,793029,179827,384531,2110,1038639,872409,351501,27278,338382,945946,206822,454584,682946,985852,781185,1043061,873101,576636,230096,151192,900198,975482,605999,961486,872527,571037,331086,946056,953817,412904,523337,1033725,350116,887932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]