SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522834 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522834 [ RunTime:0.003749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906290,786123,848442,97890,16509,987420,155048,1025583,837360,635773,4176,437680,508467,822526,553339,340535,819701,122543,304479,79244,1025229,667492,326923,1035381,403270,232190,813871,116017,12245,78873,333932,566350,796229,1108,579173,569451,328198,1020583,476756,538097,493694,267001,416007,945628,975006,199673,510073,881464,713962,359421,162931,37176,612687,441578,613147,629602,585743,759171,773349,412021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001500s ]