SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045777 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045777 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59740,455518,148495,961145,382855,812664,27288,554314,72814,470553,536301,28080,260212,323980,960396,779552,515930,788025,919124,434094,237569,420836,116019,44418,980860,922631,582811,1041409,571446,141610,634187,34667,470466,468579,330456,544240,869900,721998,303162,704411,607514,80392,1004347,140407,572611,67931,338713,363261,191317,130365,497213,98152,705741,203915,898843,1005253,87677,963086,474990,854747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045777 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045777 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]