SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313701 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313701 [ RunTime:0.005831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424116,234453,572318,272865,1013836,874585,250802,463476,840302,125314,630737,342072,143341,355324,904664,290175,872856,502432,922159,71950,694479,337802,936261,168113,215547,294832,132292,646231,660481,1041801,993680,432796,138050,747840,522147,325699,107714,1033654,351707,412776,798345,941888,438330,502380,467714,702814,682569,578768,176756,467975,312522,927082,793273,607148,212858,661497,506315,179787,527254,569707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]